/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 10:16:01
*/


-- ----------------------------
-- Table structure for tb0072
-- ----------------------------
DROP TABLE [dbo].[tb0072]
GO
CREATE TABLE [dbo].[tb0072] (
[ScreenID] varchar(20) NOT NULL ,
[GroupID] varchar(20) NOT NULL ,
[ModuleID] varchar(20) NOT NULL ,
[TaskID] char(10) NOT NULL ,
[IsAddNew] tinyint NOT NULL DEFAULT ((0)) ,
[IsUpdate] tinyint NOT NULL DEFAULT ((0)) ,
[IsDelete] tinyint NOT NULL DEFAULT ((0)) ,
[IsView] tinyint NOT NULL DEFAULT ((0)) ,
[IsPrint] tinyint NOT NULL DEFAULT ((0)) ,
[IsExport] tinyint NOT NULL DEFAULT ((0)),
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL 
)


GO

-- ----------------------------
-- Indexes structure for table tb0072
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb0072
-- ----------------------------
ALTER TABLE [dbo].[tb0072] ADD PRIMARY KEY NONCLUSTERED ([ScreenID], [GroupID], [ModuleID])
GO
